Date Conversions & Relate

Ben

When using MYSQL I need to find all entries in a table where month(date) - (1 -12)

So:- month(table.date) = 1

In Fast Report using the "where" option for table.date the script does not work.

Any suggestion where I an going wrong?

New kid on the block.

Mick.pl

Try solution like below. I tested it with FR demo table customer:

ADOTable1.Filter := 'custno < 2000';
ADOTable1.Filtered := true;

Mick